﻿

alter PROCEDURE [PomPropertyImageSelectMainImage]
(
	@pPomplingAddressID INT
)

AS
BEGIN
	SET NOCOUNT ON;	
	SELECT [DisplayPicturePath], [PictureTitle]
	FROM [PomPropertyImages] p
	WHERE p.PomplingAddressID = @pPomplingAddressID AND IsMainImage = 1 AND p.IsDeleted = 0;
END
